/*CREATE PROCEDURE [dbo].[UpdateProjectCategories]
@projectID INT, @categoryID INT, @duration FLOAT, @isRemoved BIT
AS
BEGIN
    SET NOCOUNT ON;

IF ( @isRemoved = 1)
		DELETE FROM [dbo].[ProjectCategories]
		WHERE [ProjectID] = @projectID and [CategoryID] = @categoryID
ELSE
	BEGIN
		UPDATE [dbo].[ProjectCategories]
			SET [Duration] = @duration
			WHERE [ProjectID] = @projectID and [CategoryID] = @categoryID
 
		IF (@@ROWCOUNT = 0 )
		BEGIN
			INSERT INTO [dbo].[ProjectCategories]
			(	ProjectID, CategoryID, Duration)	
			VALUES 
			(
				@projectID, @categoryID, @duration
			)
		END
	END
END;*/

